This is probably one of the posts that never will be completed, as the tools I use change over time. However at the moment this is an overview of the tools I use and how to find them.
| DBA Tools | Community driven SQL Server PowerShell module, which continously gets more functions and features. |
| Ola Hallengren Maintenance Solution | The maintenance tool to help you automate the maintenance you absolutely need! |
| sp_WhoIsActive | A comprehensive activity monitoring sp, which is a helpful troubleshooting partner. Created by Adam Machanic |
| sp_Blitz | Discover your database servers possibilities for improvement. Created by Brent Ozar |
| SQL Server Diagnostic Queries | Magnificent DMV Queries which will provide you with information you did not even thought you wanted. Created by Glenn Berry |
| DBAChecks | You probably need to validate your environment, and this is a good tool for it. |
| SQL Server Management Studio | Perhaps a given, but it is the main tool used by most DBAs I would recon. |
| Azure Data Studio | Azure Data Studio (previously SQL Server Operations Studio), a tool focusing on getting an overview and documenting stuff. |
| Microsoft Update Catalog | Good to have should you need to patch servers offline. |
| Execution Plan Reference | SQL Server Execution Plan Reference Created by Hugo Kornelis |
| Wait Types | SQL Server Wait Types Library Created by SQLSkills |
| Latch Classes | SQL Server Latch Classes Library Created by SQLSkills |
DBA Notes 